{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Geometric Mean","INR Ver Calc"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Geometric Mean","index":0,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,1,2,2],[29,0,29,7],[30,0,30,7]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 13-Jun-2023. Last reviewed on 13-Jun-2023.\r\nVAL 2010 (version 1.0). INR Calculator Worksheet. Page 1 of 2"]
[null,"Geometric Mean"]
[null,"Samples","PT Results"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,"GeoMean",{"$f":"GEOMEAN(C5:C24)","v":{"$error":"#NUM!"}}]
[]
[]
[]
["Note:"]
["1. Enter Prothrombin Time (PT) results "]
["2. Geometric Mean will automatically be calculated "]

{"sheet":"INR Ver Calc","index":1,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,0,2,11],[27,0,27,3],[26,0,26,3],[35,0,35,3],[3,5,3,11],[4,5,4,11],[6,5,6,11],[5,5,5,11],[7,5,7,11],[8,0,8,3],[17,0,17,3],[7,0,7,4],[3,0,3,4],[56,0,56,7],[6,0,6,4],[5,0,5,4],[4,0,4,4],[54,0,54,7],[55,0,55,7],[43,3,43,4],[18,0,18,3],[9,0,9,3]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 13-Jun-2023. Last reviewed on 13-Jun-2023.\r\nVAL 2010 (version 1.0). INR Calculator Worksheet. Page 2 of 2"]
["INR Verification Calculator"]
["Instrument Name and Serial Number"]
["PT Reagent Name and Lot Number"]
["PT Reagent Expiration Date"]
["INR Certified Plasma Name and Lot Number"]
["INR Certified Plasma Expiration Date:"]
["Day 1"]
["Results"]
[null,"Rep 1","Rep 2","Avg"]
["Sample 1",null,null,{"$f":"AVERAGE(B12:C12)","v":{"$error":"#DIV/0!"}}]
["Sample 2",null,null,{"$f":"AVERAGE(B13:C13)","v":{"$error":"#DIV/0!"}}]
["Sample 3",null,null,{"$f":"AVERAGE(B14:C14)","v":{"$error":"#DIV/0!"}}]
["Sample 4",null,null,{"$f":"AVERAGE(B15:C15)","v":{"$error":"#DIV/0!"}},"`"]
["Sample 5",null,null,{"$f":"AVERAGE(B16:C16)","v":{"$error":"#DIV/0!"}}]
[]
["Day 2"]
["Results"]
[null,"Rep 1","Rep 2","Avg"]
["Sample 1",null,null,{"$f":"AVERAGE(B21:C21)","v":{"$error":"#DIV/0!"}}]
["Sample 2",null,null,{"$f":"AVERAGE(B22:C22)","v":{"$error":"#DIV/0!"}}]
["Sample 3",null,null,{"$f":"AVERAGE(B23:C23)","v":{"$error":"#DIV/0!"}}]
["Sample 4",null,null,{"$f":"AVERAGE(B24:C24)","v":{"$error":"#DIV/0!"}}]
["Sample 5",null,null,{"$f":"AVERAGE(B25:C25)","v":{"$error":"#DIV/0!"}}]
[]
["Day 3"]
["Results"]
[null,"Rep 1","Rep 2","Avg"]
["Sample 1",null,null,{"$f":"AVERAGE(B30:C30)","v":{"$error":"#DIV/0!"}}]
["Sample 2",null,null,{"$f":"AVERAGE(B31:C31)","v":{"$error":"#DIV/0!"}}]
["Sample 3",null,null,{"$f":"AVERAGE(B32:C32)","v":{"$error":"#DIV/0!"}}]
["Sample 4",null,null,{"$f":"AVERAGE(B33:C33)","v":{"$error":"#DIV/0!"}}]
["Sample 5",null,null,{"$f":"AVERAGE(B34:C34)","v":{"$error":"#DIV/0!"}}]
[]
["Average for all Results"]
[null,"Day 1","Day 2","Day 3","Avg"]
["Sample 1",null,null,null,{"$f":"AVERAGE(C38:D38)","v":{"$error":"#DIV/0!"}}]
["Sample 2",null,null,null,{"$f":"AVERAGE(C39:D39)","v":{"$error":"#DIV/0!"}}]
["Sample 3",null,null,null,{"$f":"AVERAGE(C40:D40)","v":{"$error":"#DIV/0!"}}]
["Sample 4",null,null,null,{"$f":"AVERAGE(C41:D41)","v":{"$error":"#DIV/0!"}}]
["Sample 5",null,null,null,{"$f":"AVERAGE(C42:D42)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Calculated INR","Expected INR","Expected Range      Lower         Upper",null,"Acceptable Yes/No"]
["Sample 1",null,null,{"$f":"C45-(0.15*C45)","v":0},{"$f":"C45+(0.15*C45)","v":0},{"$f":"IF(AND(D45<B45,B45<E45),\"Yes\",\"No\")","v":"No"}]
["Sample 2",null,null,{"$f":"C46-(0.15*C46)","v":0},{"$f":"C46+(0.15*C46)","v":0},{"$f":"IF(AND(D46<B46,B46<E46),\"Yes\",\"No\")","v":"No"}]
["Sample 3",null,null,{"$f":"C47-(0.15*C47)","v":0},{"$f":"C47+(0.15*C47)","v":0},{"$f":"IF(AND(D47<B47,B47<E47),\"Yes\",\"No\")","v":"No"}]
["Sample 4",null,null,{"$f":"C48-(0.15*C48)","v":0},{"$f":"C48+(0.15*C48)","v":0},{"$f":"IF(AND(D48<B48,B48<E48),\"Yes\",\"No\")","v":"No"}]
["Sample 5",null,null,{"$f":"C49-(0.15*C49)","v":0},{"$f":"C49+(0.15*C49)","v":0},{"$f":"IF(AND(D49<B49,B49<E49),\"Yes\",\"No\")","v":"No"}]
[]
[]
[]
[]
["Note:"]
["1. Calculated INR is the INR calculated using the geometric mean and ISI of the reagent."]
["2. Expected INR should be included in the package insert of the verification kit."]
["3. Expected range is calculated from the Expected INR of each sample +/- 15%. If acceptable criteria is different, use criteria for the kit."]